using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
using ReflectionStudio.Core.Events;
using System;
namespace WPFExcelReport
{
    public partial class VLMFKART
    {
       
        private string _CGRP = "";
        public string CGRP
        {
            get { return _CGRP; }
            set
            {
                _CGRP = value;
                if (dwLM != null)
                {
                    dwLM["LMFPREISGRP"] = CGRP;
                }
                OnPropertyChanged("CGRP", value);
            }
        } 
        private DataRow _dwLM = null; public DataRow dwLM { get { return _dwLM; } set { _dwLM = value; OnPropertyChanged("dwLM", value); } }
        public void LMLOAD(string cardno)
        { 
            dwData = TBMain.NewRow();
            dwData["LMFMANDANT"] = app.Mandant;
            dwData["LMFKARTNR"] = cardno;
            SResult = QueryLMFKART(dwData, 2);
            MergeData(SResult, false);
        }
     
    }
    public partial class VLMFKART
    {

        public string LMFMANDANT { get { if (dwMaster == null) return ""; return dwMaster["LMFMANDANT"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFMANDANT"] = value; OnPropertyChanged("LMFMANDANT", value); } } //lENGth 2
        public string LMFKUNDNR { get { if (dwMaster == null) return ""; return dwMaster["LMFKUNDNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFKUNDNR"] = value; OnPropertyChanged("LMFKUNDNR", value); } } //lENGth 8
        public string LMFKARTNR { get { if (dwMaster == null) return ""; return dwMaster["LMFKARTNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFKARTNR"] = value; OnPropertyChanged("LMFKARTNR", value); } } //lENGth 10
        public string LMFFARBE { get { if (dwMaster == null) return ""; return dwMaster["LMFFARBE"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFFARBE"] = value; OnPropertyChanged("LMFFARBE", value); } } //lENGth 10
        public string LMFDESS { get { if (dwMaster == null) return ""; return dwMaster["LMFDESS"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFDESS"] = value; OnPropertyChanged("LMFDESS", value); } } //lENGth 10
        public string LMFCOLORIT { get { if (dwMaster == null) return ""; return dwMaster["LMFCOLORIT"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFCOLORIT"] = value; OnPropertyChanged("LMFCOLORIT", value); } } //lENGth 10
        public string LMFBEZ { get { if (dwMaster == null) return ""; return dwMaster["LMFBEZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFBEZ"] = value; OnPropertyChanged("LMFBEZ", value); } } //lENGth 20
        public string LMFVORLNR { get { if (dwMaster == null) return ""; return dwMaster["LMFVORLNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFVORLNR"] = value; OnPropertyChanged("LMFVORLNR", value); } } //lENGth 15
        public string LMFPREISGRP { get { if (dwMaster == null) return ""; return dwMaster["LMFPREISGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFPREISGRP"] = value; OnPropertyChanged("LMFPREISGRP", value); } } //lENGth 1
        public string LMFGRPBEZ { get { if (dwMaster == null) return ""; return dwMaster["LMFGRPBEZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFGRPBEZ"] = value; OnPropertyChanged("LMFGRPBEZ", value); } } //lENGth 20
        public string LMFRUESTGRP { get { if (dwMaster == null) return ""; return dwMaster["LMFRUESTGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFRUESTGRP"] = value; OnPropertyChanged("LMFRUESTGRP", value); } } //lENGth 3
        public string LMFPRUEFGRP { get { if (dwMaster == null) return ""; return dwMaster["LMFPRUEFGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFPRUEFGRP"] = value; OnPropertyChanged("LMFPRUEFGRP", value); } } //lENGth 1
        public string LMFROHFARBE { get { if (dwMaster == null) return ""; return dwMaster["LMFROHFARBE"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFROHFARBE"] = value; OnPropertyChanged("LMFROHFARBE", value); } } //lENGth 10
        public string LMFMUDESS { get { if (dwMaster == null) return ""; return dwMaster["LMFMUDESS"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFMUDESS"] = value; OnPropertyChanged("LMFMUDESS", value); } } //lENGth 10
        public string LMFUNIFARB { get { if (dwMaster == null) return ""; return dwMaster["LMFUNIFARB"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFUNIFARB"] = value; OnPropertyChanged("LMFUNIFARB", value); } } //lENGth 10
        public double LMFSCHABANZ { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFSCHABANZ"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFSCHABANZ"] = value; OnPropertyChanged("LMFSCHABANZ", value); } } //lENGth 0
        public double LMFUSCHABANZ { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFUSCHABANZ"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFUSCHABANZ"] = value; OnPropertyChanged("LMFUSCHABANZ", value); } } //lENGth 0
        public string LMFFDVF { get { if (dwMaster == null) return ""; return dwMaster["LMFFDVF"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFFDVF"] = value; OnPropertyChanged("LMFFDVF", value); } } //lENGth 3
        public string LMFEZUSTAND1 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND1"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND1"] = value; OnPropertyChanged("LMFEZUSTAND1", value); } } //lENGth 4
        public string LMFEZUSTAND2 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND2"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND2"] = value; OnPropertyChanged("LMFEZUSTAND2", value); } } //lENGth 4
        public string LMFEZUSTAND3 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND3"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND3"] = value; OnPropertyChanged("LMFEZUSTAND3", value); } } //lENGth 4
        public string LMFEZUSTAND4 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND4"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND4"] = value; OnPropertyChanged("LMFEZUSTAND4", value); } } //lENGth 4
        public string LMFEZUSTAND5 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND5"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND5"] = value; OnPropertyChanged("LMFEZUSTAND5", value); } } //lENGth 4
        public string LMFEZUSTAND6 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND6"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND6"] = value; OnPropertyChanged("LMFEZUSTAND6", value); } } //lENGth 4
        public string LMFEZUSTAND7 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND7"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND7"] = value; OnPropertyChanged("LMFEZUSTAND7", value); } } //lENGth 4
        public string LMFEZUSTAND8 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND8"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND8"] = value; OnPropertyChanged("LMFEZUSTAND8", value); } } //lENGth 4
        public string LMFEZUSTAND9 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND9"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND9"] = value; OnPropertyChanged("LMFEZUSTAND9", value); } } //lENGth 4
        public string LMFEZUSTAND10 { get { if (dwMaster == null) return ""; return dwMaster["LMFEZUSTAND10"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFEZUSTAND10"] = value; OnPropertyChanged("LMFEZUSTAND10", value); } } //lENGth 4
        public double LMFFA { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFFA"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFFA"] = value; OnPropertyChanged("LMFFA", value); } } //lENGth 0
        public double LMFGA { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFGA"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFGA"] = value; OnPropertyChanged("LMFGA", value); } } //lENGth 0
        public double LMFQA { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFQA"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFQA"] = value; OnPropertyChanged("LMFQA", value); } } //lENGth 0
        public double LMFQPKTH { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFQPKTH"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFQPKTH"] = value; OnPropertyChanged("LMFQPKTH", value); } } //lENGth 0
        public double LMFQPKTLH { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFQPKTLH"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFQPKTLH"] = value; OnPropertyChanged("LMFQPKTLH", value); } } //lENGth 0
        public string LMFSFKZ { get { if (dwMaster == null) return ""; return dwMaster["LMFSFKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFSFKZ"] = value; OnPropertyChanged("LMFSFKZ", value); } } //lENGth 1
        public string LMFRGBWERT1 { get { if (dwMaster == null) return "000"; return dwMaster["LMFRGBWERT1"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFRGBWERT1"] = value; OnPropertyChanged("LMFRGBWERT1", value); } } //lENGth 3
        public string LMFRGBWERT2 { get { if (dwMaster == null) return "000"; return dwMaster["LMFRGBWERT2"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFRGBWERT2"] = value; OnPropertyChanged("LMFRGBWERT2", value); } } //lENGth 3
        public string LMFRGBWERT3 { get { if (dwMaster == null) return "000"; return dwMaster["LMFRGBWERT3"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFRGBWERT3"] = value; OnPropertyChanged("LMFRGBWERT3", value); } } //lENGth 3
        public string LMFKZDUMCOL { get { if (dwMaster == null) return ""; return dwMaster["LMFKZDUMCOL"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFKZDUMCOL"] = value; OnPropertyChanged("LMFKZDUMCOL", value); } } //lENGth 1
        public string LMFSUBSYS { get { if (dwMaster == null) return ""; return dwMaster["LMFSUBSYS"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFSUBSYS"] = value; OnPropertyChanged("LMFSUBSYS", value); } } //lENGth 2
        public string LMFKZNOGEN { get { if (dwMaster == null) return ""; return dwMaster["LMFKZNOGEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFKZNOGEN"] = value; OnPropertyChanged("LMFKZNOGEN", value); } } //lENGth 1
        public string LMFPRODSTA { get { if (dwMaster == null) return ""; return dwMaster["LMFPRODSTA"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFPRODSTA"] = value; OnPropertyChanged("LMFPRODSTA", value); } } //lENGth 1
        public string LMFKATFARBE { get { if (dwMaster == null) return ""; return dwMaster["LMFKATFARBE"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFKATFARBE"] = value; OnPropertyChanged("LMFKATFARBE", value); } } //lENGth 10
        public string LMFFILLER { get { if (dwMaster == null) return ""; return dwMaster["LMFFILLER"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFFILLER"] = value; OnPropertyChanged("LMFFILLER", value); } } //lENGth 52
        public double LMFAENDZL { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFAENDZL"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFAENDZL"] = value; OnPropertyChanged("LMFAENDZL", value); } } //lENGth 0
        public string LMFAENDBEN { get { if (dwMaster == null) return ""; return dwMaster["LMFAENDBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFAENDBEN"] = value; OnPropertyChanged("LMFAENDBEN", value); } } //lENGth 8
        public double LMFAENDDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFAENDDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFAENDDAT"] = value; OnPropertyChanged("LMFAENDDAT", value); } } //lENGth 0
        public string LMFNEUBEN { get { if (dwMaster == null) return ""; return dwMaster["LMFNEUBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["LMFNEUBEN"] = value; OnPropertyChanged("LMFNEUBEN", value); } } //lENGth 8
        public double LMFNEUDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["LMFNEUDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["LMFNEUDAT"] = value; OnPropertyChanged("LMFNEUDAT", value); } } //lENGth 0

    }
}
